﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization;
using System.Data.SqlClient;

namespace WEB.Exceptions
{
    /// <summary>
    /// Represents errors that occur during application execution
    /// </summary>
    [Serializable]
    public class DBException : ApplicationException
    {
        public int Number { get; set; }
        /// <summary>
        /// Initializes a new instance of the Exception class.
        /// </summary>
        public DBException()
        {

        }

        /// <summary>
        /// Initializes a new instance of the Exception class with a specified error message.
        /// </summary>
        /// <param name="message">The message that describes the error.</param>
        public DBException(string message)
            : base(message)
        {
        }
        public DBException(string message, int number)
            : base(message)
        {
            this.Number = number;
        }

        /// <summary>
        /// Initializes a new instance of the Exception class with serialized data.
        /// </summary>
        /// <param name="info">The SerializationInfo that holds the serialized object data about the exception being thrown.</param>
        /// <param name="context">The StreamingContext that contains contextual information about the source or destination.</param>
        protected DBException(SerializationInfo
            info, StreamingContext context)
            : base(info, context)
        {
        }

        /// <summary>
        /// Initializes a new instance of the Exception class with a specified error message and a reference to the inner exception that is the cause of this exception.
        /// </summary>
        /// <param name="message">The error message that explains the reason for the exception.</param>
        /// <param name="innerException">The exception that is the cause of the current exception, or a null reference if no inner exception is specified.</param>
        public DBException(string message, Exception innerException)
            : base(message, innerException)
        {
            if (innerException is SqlException)
            {
                SqlException ex = (SqlException)innerException;
                this.Number = ex.Number;
            }
        }
    }
}
